This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have a pipeline that creates a staging table in a SQL database that is then compared to a target table using a SQLserver stored procedure. It is important that the staging table be completely p...
We have a specific requirement where we need to import some data from several sources (example: Snowflake) and load them in SQLServer on premise table. Once that is done, some of the columns of t...
A statement like this works fine in SQLServer. How can I get something like this to work in the SQLServer - Execute Snap? There has to be a syntax issue that I have. Any help is appreciated.
D...
Hi Community,
I was trying to access SQLserver via snaplogic but I wasn’t successful as I was facing an issue with the connection. Below are the two error messages when I tried with different p...
Hello All,
I create a pipeline to create a target table based on source table, the steps in the pipeline are: 1.DROP the target table if exists → 2.Create the table if not exists -->3. Modify so...
I have a pipeline that I am working on that requires data to be extracted and transformed in SQLServer (completed) and should be loaded into a single excel file. I cant seem to get my data into an e...
Has anyone had success using JTDS to connect to MS SQLServer or Sybase? I have client tools working without issue, but, can not seem to get it to work in Snaplogic with the same configuration u...
Hi Team
I am getting error while validating SQLserver account from snaplogic which will connect to SQLserver with windows 2003.
And getting error as below, can any one help me on this please....
Hi Team,
when i write two statement in sqlserver execute snap. e.g first is truncate table and then load table it does not error out if the second sql statement fails.
Can you please let ,me k...
SnapLogic_SQL_server_timeout_errors.docx (120.0 KB)
Hello All,
I am getting intermittent SQLServer connection error as below
Failed to retrieve a database connection. Also uploaded the d...